alter proc [dbo].[spLayChiTietKho] (@maKho int)
as
begin
	select *
	from ChiTietKho,NguyenLieu,NhaCungCap,DonViTinh,LoaiNguyenLieu
	where  ChiTietKho.MaKho = @maKho and ChiTietKho.MaNL = NguyenLieu.MaNL and NhaCungCap.MaNCC = NguyenLieu.MaNCC
			and DonViTinh.MaDVTinh = NguyenLieu.MaDVTinh and LoaiNguyenLieu.MaLoaiNL = NguyenLieu.MaLoaiNL
end